價格：免費
更新日期：2020-06-02
檔案大小：2.8 MB
目前版本：1.2.2
版本需求：系統需求：iOS 13.0 或以後版本。相容裝置：iPhone、iPad、iPod touch。
支援語言：英語
APP CREATED FOR LEARNING AND VALIDATING THE SQL LANGUAGE IN SQL SERVER
. . . . . . . . . . . . . . . . . . . . .
This App acts as a reference for the SQL language, with two main features:
Validate SQL code through Augmented Reality (Text Recognition - possibility to take a picture of the code on your PC)
Learn DML & DDL statements with description, syntax, notes and examples
For each statement is presented:
Detailed description of the statement/command purpose
Syntax of the statement with the various options
Two examples executed from a real table (Automobile Table)
FEATURE 1 - SQL VALIDATOR
__________________________________
This application provides a validator that intends to check if a DML or DDL statement is syntactically correct. This feature is fantastic for those who are starting to learn the SQL language.
Functionalities:
1.1) Capture SQL code directly from the PC monitor (and directly from SQL Server, Oracle, MySQL or Access query window)
1.2) Write an SQL statement directly in the application
2) Step-by-step validation with clear error indication (with suggestions and automatic corrections)
Note:
Select and Create statement is not yet available for Validation. Likewise, sub-queries, expressions and column and table names using spaces are not yet evaluated.
We are working on this feature which will be available in a future release.
Statements available:
- INSERT
- UPDATE
- DELETE
- ALTER (Database, Table or Indexes)
- DROP (Database, Table or Constraints)
FEATURE 2 – SQL REFERENCE
__________________________________
1. GENERAL
1.1 - Comments
1.2 - Data Types
2. (DML) Data Manipulation Language
2.1 – SELECT
- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Top, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union, Intersect, Except (Any & All)
- Subqueries
- Joins (Inner, Full, Right, Left)
- Select Into
2.2 - INSERT
- With Columns names
- Without Column names
- Rules
- Insert Into ... Select
2.3 - DELETE
- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity
2.4 - UPDATE
- Update All Rows
- Update ... Where
- Rules
3. (DDL) DATA DEFINITION LANGUAGE
3.1 - CREATE
- Create Database
- Create Table
- Create Index
- Auto-Increment
- Constraints (PK, FK, CK, DF, UQ, NN, IX)
3.2 - ALTER
- Alter Columns
- Add Constraints
- Drop Constrains
3.3 - DROP
- Drop Table
- Drop Database
- Drop Index
3.4 - TUNCATE
- Delete Versus Truncate
